CREATE TABLE [dbo].[Users](
	[UserId] [uniqueidentifier] NOT NULL,
	[PersonOrEntityIdentifier] [nvarchar](200) NOT NULL,
	[UserGroupId] [uniqueidentifier] NULL,
	[Name] [nvarchar](250) NOT NULL,
	[Username] [nvarchar](50) NOT NULL,
	[Password] [nvarchar](50) NOT NULL,
	[Email] [nvarchar](250) NULL,
	[IsRegistrationCompleted] [bit] NULL,
	[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY ([UserId])
 )
GO